create or replace view vac_application_item as
with ai as
(
 select item_name,
        data_type,
        session_state_protection,
        build_option,
        component_comment,
        application_id
 from APEX_APPLICATION_ITEMS
)
select application_id,
       item_name,
       U_NAME,
       U_VALUE,
       'APEX_APPLICATION_ITEMS' src_view_name
from ai
 UNPIVOT INCLUDE NULLS ( u_value
   FOR    u_name
   IN
   (    data_type,
        session_state_protection,
        build_option,
        component_comment
   )
 );

